// See the DataAccess setup code on the DataAccess class page.

// Executes a DB script file.
private static void ExecuteScript(DataAccess dataAccess)
{
  // Create a DB Script file.
  StringBuilder builder = new StringBuilder(64);
  builder.AppendLine("insert into TestTable values('Name1');");
  builder.AppendLine("go");
  builder.AppendLine("delete from TestTable where Name = 'Name1';");
  builder.AppendLine("go");
  string scriptText = builder.ToString();
  File.WriteAllText("TestScript.sql", scriptText);

  dataAccess.ExecuteScript("TestScript.sql");
}